﻿CREATE TABLE [dbo].[People] (
    [ID]         INT            IDENTITY (1, 1) NOT NULL,
    [LastName]   NVARCHAR (40) NULL,
    [FirstName]  NVARCHAR (40) NULL,
    [DOB]        DATE       NOT NULL,
    [DateJoined] DATE       NOT NULL,
    [School]     NVARCHAR (80) NULL,
    [Homeless]   BIT            NOT NULL,
    CONSTRAINT [PK_dbo.People] PRIMARY KEY CLUSTERED ([ID] ASC)
);

